Nick Korna
Nick Korna
Reactions
-
Re: Using COUNTIF(S) with RIGHT functionality
You should be able to add this on to each COUNTIFS as it's just another criteria to check for - just remember you'll need it in each one.1 · -
Re: Anyone able to help figure out this formula?
One thing instantly leaps out - the quotation marks around Permanent FT are curved rather than straight. Change the “Permanent FT” to "Permanent FT" . Try changing this over and see what th…1 · -
Re: Using COUNTIF(S) with RIGHT functionality
Hi @mónicas, Something like this should do the trick: =COUNTIF({Record ID 3}, RIGHT(@cell, 3) >= 100) Hope this helps, but if you've any problems/questions then just post! 🙂1 · -
Re: Calculating the "Average" RAG Status
Hi @Safiya B, If you've grouped things up with indentation then you can do this. Here the formula in the project status is: =IFERROR(IF(COUNTIF(CHILDREN(Status@row), "Red") / COUNT(CHILDREN…1 · -
Re: How to count date occurrences within a month
Hi @Merritt R, The criteria should not be in the quotation marks as this will mean the COUNTIFS is looking for that as text, rather than as a function. However, checking this you'll get an error. You…1 ·
